package com.topisv.tms.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.EdiOrder;
import com.topisv.tms.entity.LogisticsCompany;
import com.topisv.tms.entity.ReturnGood;
import com.topisv.tms.entity.stock.instorage.pre.InstorageBillPre;

/**
 * 退货入库Dao
 * @author Administrator
 *
 */
public interface ReturnGoodDao extends PagingAndSortingRepository<ReturnGood, Long>,JpaSpecificationExecutor<ReturnGood>{

	@Query("select r from ReturnGood r")
	List<ReturnGood> findReturnGood();
	
	@Query("select r.status from ReturnGood r where r.returnExpress = ?1 or r.oldOrderNo = ?2")
	String findReturnGood(String returnexpressno,String oldorderno);
	
	
}
